Neroo Tal
Minmatar
Order of the Golden Dawn
Shades of Gray
   |
Posted - 2010.12.27 21:26:00 -
[1]
Not sure where to put this honestly, so hope this is the correct forum. I've been working with the data dump for a few days now, trying to muck my way through it, found a few pre-made mysql queries that had some of the information I wanted but not everything, so I played around with them a bit until I started seeing the connections that the tables began to form.
I will show you what I have, what I'm looking for is if there is a more efficient way to do the query itself and how to garner a bit more information from the queries and where to attain that information
Most specifically is this monstrosity that I've created that pulls all the relevant data I want / need for any items in game that are published
SELECT t.typeName, t.typeID, t.groupID, t.description, d.attributeName, d.displayName, d.description, a.valueInt, a.valueFloat, i.iconFile
FROM invTypes AS t
INNER JOIN dgmtypeattributes AS a
INNER JOIN dgmattributetypes AS d
INNER JOIN eveicons AS i
WHERE t.typeID = 1202 --Civilian Mining Drone
AND t.published = 1
AND t.typeID = a.typeID
AND a.attributeID = d.attributeID
AND d.iconID = i.iconID
This pulls up all the relevant data of any item by typeID; there has to be a more efficient clause than this that will extract all the necessary data and still confine it to the same / similar restraints.
From this info how would I find the icon associated with the item itself ( in this case Civilian Mining Drone ) that would show up if I looked at the item in market ( ie: search for civilian and click on civilian mining drone, the icon to the left of the words 'Civilian Mining Drone' ).
--Neroo Tal
Order of the Golden Dawn CEO : Founder |
Neroo Tal
Minmatar
Order of the Golden Dawn
Shades of Gray
|
Posted - 2010.12.29 20:10:00 -
[2]
Edited by: Neroo Tal on 29/12/2010 20:11:07
@Catari Taga: Thanks, I don't understand everything in your query but it seems to be more efficient than mine, which is what I wanted. It also pulls up missing data that I wasn't even aware was being missed.
Now question about marketGroupID, I did find out that the parentGroupID is just a marketGroupID under a different name and a recursive search will inevitably yield the market chain this item falls under. Is there a way to recursively go look up the marketGroupID chain in SQL that will produce a chain of market labels? i.e.:
Medium Shield Booster II (typeID 10850)
Medium -> Shield Boosters -> Shield -> Ship Equipment
--Edit Spelling
--Neroo Tal
Order of the Golden Dawn CEO : Founder |